/*
 Navicat Premium Data Transfer

 Source Server         : 39.101.175.193
 Source Server Type    : MySQL
 Source Server Version : 50730
 Source Host           : 127.0.01:3306
 Source Schema         : db_donald

 Target Server Type    : MySQL
 Target Server Version : 50730
 File Encoding         : 65001

 Date: 08/03/2021 20:18:02
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for controller
-- ----------------------------
DROP TABLE IF EXISTS `controller`;
CREATE TABLE `controller` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `controller_code` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_by` bigint(20) DEFAULT NULL COMMENT '创建者id',
  `modified_by` bigint(20) DEFAULT NULL COMMENT '修改者id',
  `gmt_created` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT NULL COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标志(默认0:未删除,1:已删除)',
  `version` bigint(60) NOT NULL DEFAULT '0' COMMENT '乐观锁版本',
  `creator` varchar(64) DEFAULT NULL COMMENT '创建者',
  `modifier` varchar(64) DEFAULT NULL COMMENT '更新者',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=427 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of controller
-- ----------------------------
BEGIN;
INSERT INTO `controller` VALUES (411, 'api-controller', 'Api Controller', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `controller` VALUES (412, 'code-builder-controller', '代码开发相关功能', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `controller` VALUES (413, 'feature-controller', 'Feature Controller', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `controller` VALUES (414, 'file-controller', 'File Controller', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `controller` VALUES (415, 'game-controller', 'Game Controller', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `controller` VALUES (416, 'game-feature-controller', 'Game Feature Controller', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `controller` VALUES (417, 'log-operator-controller', 'Log Operator Controller', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `controller` VALUES (418, 'log-sql-controller', 'Log Sql Controller', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `controller` VALUES (419, 'sys-dictionary-controller', '数据字典相关接口', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `controller` VALUES (420, 'sys-menu-controller', '菜单管理相关接口', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `controller` VALUES (421, 'sys-permission-controller', '角色权限管理相关接口', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `controller` VALUES (422, 'sys-role-controller', '角色管理相关接口', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `controller` VALUES (423, 'sys-user-controller', '用户管理相关功能', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `controller` VALUES (424, 'system-controller', '登录，注销，验证码等功能', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `controller` VALUES (425, 'test-controller', 'Test Controller', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `controller` VALUES (426, 'type-controller', 'Type Controller', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
COMMIT;

-- ----------------------------
-- Table structure for dictionary
-- ----------------------------
DROP TABLE IF EXISTS `dictionary`;
CREATE TABLE `dictionary` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `code` varchar(255) DEFAULT NULL COMMENT '字典编号',
  `label` varchar(255) DEFAULT NULL COMMENT '显示文本',
  `value` int(8) DEFAULT NULL COMMENT '字典值',
  `parent_code` varchar(255) DEFAULT NULL COMMENT '父字典编号',
  `description` varchar(255) DEFAULT NULL COMMENT '描述',
  `sort` int(8) DEFAULT '0' COMMENT '排序',
  `created_by` bigint(20) DEFAULT NULL COMMENT '创建者id',
  `modified_by` bigint(20) DEFAULT NULL COMMENT '修改者id',
  `gmt_created` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT NULL COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标志(默认0:未删除,1:已删除)',
  `version` bigint(60) NOT NULL DEFAULT '0' COMMENT '乐观锁版本',
  `creator` varchar(64) DEFAULT NULL COMMENT '创建者',
  `modifier` varchar(64) DEFAULT NULL COMMENT '更新者',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of dictionary
-- ----------------------------
BEGIN;
INSERT INTO `dictionary` VALUES (1, 'sex', '性别', NULL, NULL, '性别', 0, 6, 6, '2020-11-11 20:19:44', '2020-11-12 19:48:18', 0, 0, 'root', 'root');
INSERT INTO `dictionary` VALUES (2, 'sex_male', '男', 0, 'sex', '男', 0, 6, 6, '2020-11-11 20:19:48', '2020-11-11 20:20:04', 0, 0, 'root', 'root');
INSERT INTO `dictionary` VALUES (3, 'sex_female', '女', 1, 'sex', '女', 1, 6, 6, '2020-11-11 20:19:51', '2020-11-12 21:24:19', 0, 0, 'root', 'root');
INSERT INTO `dictionary` VALUES (4, 'sex_unknown', '未知', 2, 'sex', '未知', 2, 6, 6, '2020-11-11 20:19:53', '2020-11-11 20:20:10', 0, 0, 'root', 'root');
INSERT INTO `dictionary` VALUES (5, 'conton', '广东', NULL, NULL, '广东', 1, 6, 6, '2020-11-12 21:24:19', '2020-11-12 21:24:19', 0, 0, 'root', 'root');
INSERT INTO `dictionary` VALUES (6, 'conton_guangzhou', '广州', 0, 'conton', '广州', 0, 6, 6, '2020-11-12 21:24:19', '2020-11-12 21:24:19', 0, 0, 'root', 'root');
INSERT INTO `dictionary` VALUES (7, 'conton_shenzhen', '深圳', 1, 'conton', '深圳', 1, 6, 6, '2020-11-12 21:24:19', '2020-11-12 21:24:19', 0, 0, 'root', 'root');
INSERT INTO `dictionary` VALUES (11, 'conton_dongguan', '东莞', 2, 'conton', '东莞', 2, 6, 6, '2020-11-12 21:24:19', '2020-11-12 21:24:19', 0, 0, 'root', 'root');
INSERT INTO `dictionary` VALUES (12, 'conton_zhongshan', '中山', 3, 'conton', '中山', 3, 6, 6, '2020-11-12 21:24:19', '2020-11-12 21:24:19', 0, 0, 'root', 'root');
COMMIT;

-- ----------------------------
-- Table structure for goods
-- ----------------------------
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `created_by` bigint(20) DEFAULT NULL COMMENT '创建者id',
  `modified_by` bigint(20) DEFAULT NULL COMMENT '修改者id',
  `gmt_created` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT NULL COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标志(默认0:未删除,1:已删除)',
  `version` bigint(60) NOT NULL DEFAULT '0' COMMENT '乐观锁版本',
  `goods_name` varchar(64) DEFAULT NULL COMMENT '商品名称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of goods
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for login
-- ----------------------------
DROP TABLE IF EXISTS `login`;
CREATE TABLE `login` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户id',
  `ip_login` varchar(64) DEFAULT NULL COMMENT '当前登录ip',
  `gmt_last_login` datetime DEFAULT NULL COMMENT '上次登录时间',
  `ip_last_login` varchar(64) DEFAULT NULL COMMENT '上次登录ip',
  `authorization` varchar(255) DEFAULT NULL COMMENT '登录的token(单点登录用)',
  `created_by` bigint(20) DEFAULT NULL COMMENT '创建者id',
  `modified_by` bigint(20) DEFAULT NULL COMMENT '修改者id',
  `gmt_created` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT NULL COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标志(默认0:未删除,1:已删除)',
  `version` bigint(60) NOT NULL DEFAULT '0' COMMENT '乐观锁版本',
  `creator` varchar(64) DEFAULT NULL COMMENT '创建者',
  `modifier` varchar(64) DEFAULT NULL COMMENT '更新者',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of login
-- ----------------------------
BEGIN;
INSERT INTO `login` VALUES (1, 6, '14.157.93.11', '2021-02-27 14:14:11', '14.157.93.11', 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJEb25hbGQiLCJleHAiOjI2OTQ0MjMyOTEsInVzZXJOYW1lIjoicm9vdCIsInVzZXJJZCI6Nn0.bjZnDEL9dQ0GtDjB7j8GCsnhHh9H6VM0jp4cXxRqbiA', 6, 6, '2020-11-16 11:59:58', '2021-02-27 18:54:52', 0, 0, 'root', 'root');
INSERT INTO `login` VALUES (2, 7, '163.179.32.13', NULL, NULL, 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJEb25hbGQiLCJleHAiOjI2OTMxMjEwMTQsInVzZXJOYW1lIjoiZ3Vlc3QiLCJ1c2VySWQiOjd9.tPLiYqk47mCRzK24g0uWSTEZxr0KhvBuxQ-swnCVrB0', 6, 6, '2021-02-12 17:10:22', '2021-02-12 17:10:22', 0, 0, 'root', 'root');
COMMIT;

-- ----------------------------
-- Table structure for menu
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `path` varchar(255) DEFAULT NULL COMMENT '菜单名称',
  `name` varchar(64) DEFAULT NULL COMMENT '菜单访问路径',
  `parent_id` bigint(20) DEFAULT NULL COMMENT '父级菜单id',
  `sort` int(8) DEFAULT '0' COMMENT '排序',
  `description` varchar(255) DEFAULT NULL COMMENT '描述',
  `gmt_created` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT NULL COMMENT '更新时间',
  `created_by` bigint(20) DEFAULT NULL COMMENT '创建者id',
  `modified_by` bigint(20) DEFAULT NULL COMMENT '修改者id',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标志(默认0:未删除,1:已删除)',
  `version` bigint(60) DEFAULT '0' COMMENT '乐观锁版本',
  `creator` varchar(64) DEFAULT NULL COMMENT '创建者',
  `modifier` varchar(64) DEFAULT NULL COMMENT '修改者',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of menu
-- ----------------------------
BEGIN;
INSERT INTO `menu` VALUES (1, '/system', '系统管理', NULL, 0, '系统管理', '2020-11-09 22:49:46', '2020-11-09 22:49:49', 6, 6, 0, 0, 'root', 'root');
INSERT INTO `menu` VALUES (2, '/api', '接口同步', 1, 1, '接口同步', '2020-11-09 22:50:43', '2020-11-09 22:51:04', 6, 6, 0, 0, 'root', 'root');
INSERT INTO `menu` VALUES (3, '/sysRole', '角色管理', 1, 2, '角色管理', '2020-11-09 22:53:44', '2020-11-09 22:54:01', 6, 6, 0, 0, 'root', 'root');
INSERT INTO `menu` VALUES (4, '/codeBuilder', '代码生成', 1, 3, '代码生成', '2020-11-09 22:53:48', '2020-11-09 22:54:04', 6, 6, 0, 0, 'root', 'root');
INSERT INTO `menu` VALUES (5, '/sysUser', '所有用户', 1, 4, '所有用户管理', '2020-11-09 22:53:53', '2020-11-15 21:09:50', 6, 6, 0, 0, 'root', 'root');
INSERT INTO `menu` VALUES (6, '/swagger', 'Swagger', 1, 8, 'Swagger', '2020-11-09 22:53:55', '2020-11-11 21:12:35', 6, 6, 0, 0, 'root', 'root');
INSERT INTO `menu` VALUES (7, '/sysMenu', '菜单管理', 1, 6, '菜单管理', '2020-11-09 22:53:58', '2020-11-09 22:54:13', 6, 6, 0, 0, 'root', 'root');
INSERT INTO `menu` VALUES (10, '/sysDictionary', '数据字典', 1, 7, '数据字典', '2020-11-11 21:12:35', '2020-11-11 21:12:35', 6, 6, 0, 0, 'root', 'root');
INSERT INTO `menu` VALUES (11, '/log', '日志监控', NULL, 1, '日志监控', '2020-11-11 21:12:35', '2021-02-08 20:55:07', 6, 6, 0, 0, 'root', 'root');
INSERT INTO `menu` VALUES (12, '/log-sql', 'sql日志', 11, 0, 'sql日志', '2020-11-11 21:12:35', '2021-02-08 20:55:53', 6, 6, 0, 0, 'root', 'root');
INSERT INTO `menu` VALUES (14, '/log-operator', '操作日志', 11, 1, '操作日志', '2021-02-09 14:22:55', '2021-02-09 14:22:55', 6, 6, 0, 0, 'root', 'root');
COMMIT;

-- ----------------------------
-- Table structure for order
-- ----------------------------
DROP TABLE IF EXISTS `order`;
CREATE TABLE `order` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `created_by` bigint(20) DEFAULT NULL COMMENT '创建者id',
  `modified_by` bigint(20) DEFAULT NULL COMMENT '修改者id',
  `gmt_created` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT NULL COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标志(默认0:未删除,1:已删除)',
  `version` bigint(60) NOT NULL DEFAULT '0' COMMENT '乐观锁版本',
  `order_name` varchar(64) DEFAULT NULL COMMENT '订单名称',
  `creator` varchar(64) DEFAULT NULL COMMENT '创建者',
  `modifier` varchar(64) DEFAULT NULL COMMENT '更新者',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of order
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for permission
-- ----------------------------
DROP TABLE IF EXISTS `permission`;
CREATE TABLE `permission` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `permission_name` varchar(80) CHARACTER SET latin1 DEFAULT NULL COMMENT '权限名',
  `controller_code` varchar(255) DEFAULT NULL,
  `type` varchar(64) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `url` varchar(255) CHARACTER SET latin1 DEFAULT NULL COMMENT '权限接口',
  `created_by` bigint(20) DEFAULT NULL COMMENT '创建人id',
  `modified_by` bigint(20) DEFAULT NULL COMMENT '修改人id',
  `gmt_created` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT NULL COMMENT '修改时间',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标志',
  `version` bigint(60) NOT NULL DEFAULT '0' COMMENT '乐观锁版本',
  `modifier` varchar(64) CHARACTER SET latin1 DEFAULT NULL COMMENT '更新者',
  `creator` varchar(64) CHARACTER SET latin1 DEFAULT NULL COMMENT '创建者',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1610 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of permission
-- ----------------------------
BEGIN;
INSERT INTO `permission` VALUES (1532, 'api:list:post', 'api-controller', 'post', 'getList', '/api/list', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1533, 'api:sync:post', 'api-controller', 'post', 'show', '/api/sync', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1534, 'admin:codeBuilder:post', 'code-builder-controller', 'post', '代码生成接口', '/admin/codeBuilder', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1535, 'game:feature:add:post', 'feature-controller', 'post', '新增特性', '/game/feature/add', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1536, 'game:feature:delete:delete', 'feature-controller', 'delete', '删除特性', '/game/feature/delete', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1537, 'game:feature:detail:get', 'feature-controller', 'get', '根据id查询特性详情', '/game/feature/detail/{id}', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1538, 'game:feature:edit:put', 'feature-controller', 'put', '修改特性', '/game/feature/edit', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1539, 'game:feature:page:post', 'feature-controller', 'post', '分页查询特性列表', '/game/feature/page', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1540, 'file:upload:get', 'file-controller', 'get', '普通文件上传接口', '/file/upload', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1541, 'file:upload:put', 'file-controller', 'put', '普通文件上传接口', '/file/upload', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1542, 'file:upload:post', 'file-controller', 'post', '普通文件上传接口', '/file/upload', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1543, 'file:upload:delete', 'file-controller', 'delete', '普通文件上传接口', '/file/upload', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1544, 'file:upload:options', 'file-controller', 'options', '普通文件上传接口', '/file/upload', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1545, 'file:upload:head', 'file-controller', 'head', '普通文件上传接口', '/file/upload', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1546, 'file:upload:patch', 'file-controller', 'patch', '普通文件上传接口', '/file/upload', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1547, 'file:upload:trace', 'file-controller', 'trace', '普通文件上传接口', '/file/upload', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1548, 'game:game:add:post', 'game-controller', 'post', '新增游戏', '/game/game/add', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1549, 'game:game:delete:delete', 'game-controller', 'delete', '删除游戏', '/game/game/delete', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1550, 'game:game:detail:get', 'game-controller', 'get', '根据id查询游戏详情', '/game/game/detail/{id}', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1551, 'game:game:edit:put', 'game-controller', 'put', '修改游戏', '/game/game/edit', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1552, 'game:game:page:post', 'game-controller', 'post', '分页查询游戏列表', '/game/game/page', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1553, 'game:game:search:post', 'game-controller', 'post', '搜索', '/game/game/search', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1554, 'game:game-feature:add:post', 'game-feature-controller', 'post', '新增游戏-特性关系记录', '/game/game-feature/add', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1555, 'game:game-feature:delete:delete', 'game-feature-controller', 'delete', '删除游戏-特性关系记录', '/game/game-feature/delete', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1556, 'game:game-feature:find-feature:get', 'game-feature-controller', 'get', '根据游戏查询特性', '/game/game-feature/find-feature', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1557, 'game:game-feature:find-game:get', 'game-feature-controller', 'get', '根据特性查询', '/game/game-feature/find-game', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1558, 'log-operator:page:post', 'log-operator-controller', 'post', '分页查询操作日志', '/log-operator/page', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1559, 'log-sql:getByAndMethod:post', 'log-sql-controller', 'post', '根据方法名获取sql日志', '/log-sql/getByAndMethod', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1560, 'log-sql:page-group:post', 'log-sql-controller', 'post', '分页获取sql日志汇总', '/log-sql/page-group', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1561, 'sysDictionary:add:post', 'sys-dictionary-controller', 'post', '添加字典', '/sysDictionary/add', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1562, 'sysDictionary:deleteAndChild:delete', 'sys-dictionary-controller', 'delete', '删除字典属性或分组', '/sysDictionary/deleteAndChild/{id}', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1563, 'sysDictionary:edit:put', 'sys-dictionary-controller', 'put', '修改字典', '/sysDictionary/edit', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1564, 'sysDictionary:getByParentCode:get', 'sys-dictionary-controller', 'get', '根据父级字典获取字典组', '/sysDictionary/getByParentCode', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1565, 'sysDictionary:getParentList:post', 'sys-dictionary-controller', 'post', '获取数据字典分组父集合', '/sysDictionary/getParentList', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1566, 'sysMenu:add:post', 'sys-menu-controller', 'post', '获取菜单', '/sysMenu/add', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1567, 'sysMenu:delete:delete', 'sys-menu-controller', 'delete', '删除菜单', '/sysMenu/delete/{id}', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1568, 'sysMenu:edit:put', 'sys-menu-controller', 'put', '编辑菜单', '/sysMenu/edit', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1569, 'sysMenu:getByParentId:post', 'sys-menu-controller', 'post', '根据parentId获取菜单', '/sysMenu/getByParentId', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1570, 'sysMenu:getParentList:post', 'sys-menu-controller', 'post', '获取顶级菜单', '/sysMenu/getParentList', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1571, 'sysMenu:getTree:post', 'sys-menu-controller', 'post', '获取菜单树形集合', '/sysMenu/getTree', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1572, 'sysMenu:getTreeByNotRoleId:get', 'sys-menu-controller', 'get', '根据角色id获取未分配的菜单', '/sysMenu/getTreeByNotRoleId', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1573, 'sysMenu:getTreeByRoleId:get', 'sys-menu-controller', 'get', '根据角色id获取已分配的菜单', '/sysMenu/getTreeByRoleId/{id}', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1574, 'sysMenu:getTreeByUser:post', 'sys-menu-controller', 'post', '根据用户信息获取已分配的菜单', '/sysMenu/getTreeByUser', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1575, 'sysPermission:addRolePermission:post', 'sys-permission-controller', 'post', '给角色批量分配权限', '/sysPermission/addRolePermission', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1576, 'sysPermission:deleteRolePermission:post', 'sys-permission-controller', 'post', '移除已分配的权限', '/sysPermission/deleteRolePermission', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1577, 'sysPermission:getByNotRoleId:get', 'sys-permission-controller', 'get', '获取角色未拥有的角色集合', '/sysPermission/getByNotRoleId', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1578, 'sysPermission:getByRoleId:get', 'sys-permission-controller', 'get', '获取角色已拥有的权限集合', '/sysPermission/getByRoleId', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1579, 'sysPermission:getTreeByRoleId:get', 'sys-permission-controller', 'get', '获取角色已拥有的树形权限集合', '/sysPermission/getTreeByRoleId', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1580, 'sysRole:add:post', 'sys-role-controller', 'post', '新增角色', '/sysRole/add', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1581, 'sysRole:addUserRole:post', 'sys-role-controller', 'post', '用户角色批量分配', '/sysRole/addUserRole', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1582, 'sysRole:delete:delete', 'sys-role-controller', 'delete', '删除角色', '/sysRole/delete/{id}', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1583, 'sysRole:deleteUserRole:post', 'sys-role-controller', 'post', '移除用户已分配的权限', '/sysRole/deleteUserRole', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1584, 'sysRole:edit:put', 'sys-role-controller', 'put', '编辑角色', '/sysRole/edit', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1585, 'sysRole:getByNotUserId:get', 'sys-role-controller', 'get', '获取用户未拥有的角色', '/sysRole/getByNotUserId', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:18', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1586, 'sysRole:getByUserId:get', 'sys-role-controller', 'get', '获取用户已拥有的角色', '/sysRole/getByUserId', 6, 6, '2021-02-25 23:25:18', '2021-02-25 23:25:19', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1587, 'sysRole:getList:post', 'sys-role-controller', 'post', '查询全集合', '/sysRole/getList', 6, 6, '2021-02-25 23:25:19', '2021-02-25 23:25:19', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1588, 'sysRole:getPage:post', 'sys-role-controller', 'post', '角色分页查询', '/sysRole/getPage', 6, 6, '2021-02-25 23:25:19', '2021-02-25 23:25:19', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1589, 'sysUser:add:post', 'sys-user-controller', 'post', '新增管理员用户', '/sysUser/add', 6, 6, '2021-02-25 23:25:19', '2021-02-25 23:25:19', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1590, 'sysUser:changePassword:post', 'sys-user-controller', 'post', '修改密码', '/sysUser/changePassword', 6, 6, '2021-02-25 23:25:19', '2021-02-25 23:25:19', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1591, 'sysUser:delete:delete', 'sys-user-controller', 'delete', '根据id删除用户', '/sysUser/delete/{id}', 6, 6, '2021-02-25 23:25:19', '2021-02-25 23:25:19', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1592, 'sysUser:edit:put', 'sys-user-controller', 'put', '根据id编辑用户', '/sysUser/edit', 6, 6, '2021-02-25 23:25:19', '2021-02-25 23:25:19', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1593, 'sysUser:editPerson:put', 'sys-user-controller', 'put', '修改个人信息', '/sysUser/editPerson', 6, 6, '2021-02-25 23:25:19', '2021-02-25 23:25:19', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1594, 'sysUser:getLoginRecord:get', 'sys-user-controller', 'get', '获取登录记录', '/sysUser/getLoginRecord', 6, 6, '2021-02-25 23:25:19', '2021-02-25 23:25:19', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1595, 'sysUser:getPage:post', 'sys-user-controller', 'post', '用户集合分页查询', '/sysUser/getPage', 6, 6, '2021-02-25 23:25:19', '2021-02-25 23:25:19', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1596, 'sysUser:person:get', 'sys-user-controller', 'get', '个人中心', '/sysUser/person', 6, 6, '2021-02-25 23:25:19', '2021-02-25 23:25:19', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1597, 'sysUser:sendPhoneVerify:post', 'sys-user-controller', 'post', '发送短信验证码', '/sysUser/sendPhoneVerify', 6, 6, '2021-02-25 23:25:19', '2021-02-25 23:25:19', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1598, 'sysUser:verifySms:post', 'sys-user-controller', 'post', '验证短信验证码', '/sysUser/verifySms', 6, 6, '2021-02-25 23:25:19', '2021-02-25 23:25:19', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1599, 'system:getCaptcha:get', 'system-controller', 'get', '获取验证码接口', '/system/getCaptcha', 6, 6, '2021-02-25 23:25:19', '2021-02-25 23:25:19', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1600, 'system:login:post', 'system-controller', 'post', '登录获取身份token接口', '/system/login', 6, 6, '2021-02-25 23:25:19', '2021-02-25 23:25:19', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1601, 'system:logout:get', 'system-controller', 'get', '用户登出接口', '/system/logout', 6, 6, '2021-02-25 23:25:19', '2021-02-25 23:25:19', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1602, 'system:preLogin:get', 'system-controller', 'get', '登录拦截提示接口', '/system/preLogin', 6, 6, '2021-02-25 23:25:19', '2021-02-25 23:25:19', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1603, 'system:register:post', 'system-controller', 'post', '用户注册接口', '/system/register', 6, 6, '2021-02-25 23:25:19', '2021-02-25 23:25:19', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1604, 'game:test:getUserId:get', 'test-controller', 'get', 'getUserIdFromRequest', '/game/test/getUserId', 6, 6, '2021-02-25 23:25:19', '2021-02-25 23:25:19', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1605, 'game:type:add:post', 'type-controller', 'post', '游戏类型添加', '/game/type/add', 6, 6, '2021-02-25 23:25:19', '2021-02-25 23:25:19', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1606, 'game:type:delete:delete', 'type-controller', 'delete', '删除类型', '/game/type/delete', 6, 6, '2021-02-25 23:25:19', '2021-02-25 23:25:19', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1607, 'game:type:detail:get', 'type-controller', 'get', '根据id查询类型详情', '/game/type/detail/{id}', 6, 6, '2021-02-25 23:25:19', '2021-02-25 23:25:19', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1608, 'game:type:edit:put', 'type-controller', 'put', '修改类型', '/game/type/edit', 6, 6, '2021-02-25 23:25:19', '2021-02-25 23:25:19', 0, 0, 'root', 'root');
INSERT INTO `permission` VALUES (1609, 'game:type:page:post', 'type-controller', 'post', '分页查询类型列表', '/game/type/page', 6, 6, '2021-02-25 23:25:19', '2021-02-25 23:25:19', 0, 0, 'root', 'root');
COMMIT;

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(64) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL COMMENT '角色描述',
  `created_by` bigint(20) DEFAULT NULL COMMENT '创建人id',
  `modified_by` bigint(20) DEFAULT NULL COMMENT '修改人id',
  `gmt_created` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT NULL COMMENT '修改时间',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标志',
  `version` bigint(60) NOT NULL DEFAULT '0' COMMENT '乐观锁版本',
  `creator` varchar(64) DEFAULT NULL COMMENT '创建者',
  `modifier` varchar(64) DEFAULT NULL COMMENT '更新者',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of role
-- ----------------------------
BEGIN;
INSERT INTO `role` VALUES (1, 'admin', '超管角色,上帝视角', 6, 6, '2020-10-24 16:32:43', '2020-10-24 16:32:50', 0, 0, 'root', 'root');
INSERT INTO `role` VALUES (2, 'customer', '顾客', 6, 6, '2020-10-24 16:32:45', '2020-10-24 16:32:52', 0, 0, 'root', 'root');
INSERT INTO `role` VALUES (3, 'seller', '卖家', 6, 6, '2020-10-24 16:32:48', '2020-11-04 23:36:05', 0, 4, 'root', 'root');
COMMIT;

-- ----------------------------
-- Table structure for role_menu
-- ----------------------------
DROP TABLE IF EXISTS `role_menu`;
CREATE TABLE `role_menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色id',
  `menu_id` bigint(20) DEFAULT NULL COMMENT '菜单id',
  `created_by` bigint(20) DEFAULT NULL COMMENT '创建者id',
  `modified_by` bigint(20) DEFAULT NULL COMMENT '修改者id',
  `gmt_created` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT NULL COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标志(默认0:未删除,1:已删除)',
  `version` bigint(60) NOT NULL DEFAULT '0' COMMENT '乐观锁版本',
  `creator` varchar(64) DEFAULT NULL COMMENT '创建者',
  `modifier` varchar(64) DEFAULT NULL COMMENT '更新者',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of role_menu
-- ----------------------------
BEGIN;
INSERT INTO `role_menu` VALUES (1, 2, 11, 6, 6, '2021-02-06 11:41:58', '2021-02-06 11:41:58', 0, 0, 'root', 'root');
INSERT INTO `role_menu` VALUES (2, 2, 12, 6, 6, '2021-02-06 11:41:58', '2021-02-06 11:41:58', 0, 0, 'root', 'root');
COMMIT;

-- ----------------------------
-- Table structure for role_permission
-- ----------------------------
DROP TABLE IF EXISTS `role_permission`;
CREATE TABLE `role_permission` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色id',
  `permission_name` varchar(255) DEFAULT NULL COMMENT '权限名称',
  `created_by` bigint(20) DEFAULT NULL COMMENT '创建者id',
  `modified_by` bigint(20) DEFAULT NULL COMMENT '修改者id',
  `gmt_created` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT NULL COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标志(默认0:未删除,1:已删除)',
  `version` bigint(60) NOT NULL DEFAULT '0' COMMENT '乐观锁版本',
  `creator` varchar(64) DEFAULT NULL COMMENT '创建者',
  `modifier` varchar(64) DEFAULT NULL COMMENT '更新者',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of role_permission
-- ----------------------------
BEGIN;
INSERT INTO `role_permission` VALUES (1, 1, '*:*:*', 6, 6, '2020-10-24 16:26:26', '2020-10-24 16:26:33', 0, 0, 'root', 'root');
INSERT INTO `role_permission` VALUES (3, 2, 'sysUser:delete:delete', 6, 6, '2020-11-07 21:34:07', '2020-11-07 21:34:07', 0, 0, 'root', 'root');
INSERT INTO `role_permission` VALUES (4, 2, 'sysUser:edit:put', 6, 6, '2020-11-07 21:34:07', '2020-11-07 21:34:07', 0, 0, 'root', 'root');
INSERT INTO `role_permission` VALUES (5, 2, 'sysUser:getPage:post', 6, 6, '2020-11-07 21:34:07', '2020-11-07 21:34:07', 0, 0, 'root', 'root');
COMMIT;

-- ----------------------------
-- Table structure for t_base
-- ----------------------------
DROP TABLE IF EXISTS `t_base`;
CREATE TABLE `t_base` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `created_by` bigint(20) DEFAULT NULL COMMENT '创建者id',
  `modified_by` bigint(20) DEFAULT NULL COMMENT '修改者id',
  `gmt_created` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT NULL COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标志(默认0:未删除,1:已删除)',
  `version` bigint(60) NOT NULL DEFAULT '0' COMMENT '乐观锁版本',
  `creator` varchar(64) DEFAULT NULL COMMENT '创建者',
  `modifier` varchar(64) DEFAULT NULL COMMENT '更新者',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of t_base
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for table_file
-- ----------------------------
DROP TABLE IF EXISTS `table_file`;
CREATE TABLE `table_file` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `url` varchar(255) DEFAULT NULL COMMENT '访问路径',
  `size` bigint(20) DEFAULT NULL COMMENT '大小',
  `origin_name` varchar(255) DEFAULT NULL COMMENT '原文件名',
  `file_name` varchar(255) DEFAULT NULL COMMENT '文件名',
  `user_id` bigint(20) DEFAULT NULL COMMENT '归属用户id',
  `suffix_name` varchar(255) DEFAULT NULL COMMENT '扩展名',
  `real_path` varchar(255) DEFAULT NULL COMMENT '真实路径',
  `created_by` bigint(20) DEFAULT NULL COMMENT '创建者id',
  `modified_by` bigint(20) DEFAULT NULL COMMENT '修改者id',
  `gmt_created` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT NULL COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标志(默认0:未删除,1:已删除)',
  `version` bigint(60) NOT NULL DEFAULT '0' COMMENT '乐观锁版本',
  `creator` varchar(64) DEFAULT NULL COMMENT '创建者',
  `modifier` varchar(64) DEFAULT NULL COMMENT '更新者',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of table_file
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_name` varchar(64) DEFAULT NULL COMMENT '用户名',
  `nick_name` varchar(64) DEFAULT NULL COMMENT '昵称',
  `real_name` varchar(64) DEFAULT NULL COMMENT '真实姓名',
  `sex` int(1) DEFAULT '2' COMMENT '性别0:男,1:女,2:未知',
  `password` varchar(64) DEFAULT NULL COMMENT '密码',
  `salt_value` varchar(64) DEFAULT NULL COMMENT '加盐值',
  `phone` varchar(64) DEFAULT NULL COMMENT '手机',
  `email` varchar(64) DEFAULT NULL COMMENT '邮箱',
  `created_by` bigint(20) DEFAULT NULL COMMENT '创建人id',
  `modified_by` bigint(20) DEFAULT NULL COMMENT '修改人id',
  `gmt_created` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT NULL COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标志默认0:未删除,1:已删除',
  `version` bigint(60) DEFAULT '0' COMMENT '乐观锁版本',
  `creator` varchar(64) DEFAULT NULL COMMENT '创建者',
  `modifier` varchar(64) DEFAULT NULL COMMENT '更新者',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (6, 'root', 'Donald', 'Donald', 2, '1ac4d2eec09b0d9c830c4d055b39c426', 'F2C1fgiX', '18977799124', '1119485678@qq.com', 6, 6, '2020-10-24 12:16:53', '2021-02-08 20:54:11', 0, 0, 'root', 'root');
INSERT INTO `user` VALUES (7, 'guest', 'Donald', 'Donald', 0, '612f6ca52f380e5f166d8d4e11df9d0d', '5Blzjw0^', '13257721069', 'xie7157648@163.com', 6, 6, '2020-10-24 12:17:12', '2020-11-11 20:29:41', 0, 7, 'root', 'root');
INSERT INTO `user` VALUES (8, 'root2', 'Donald', 'Donald', 1, '9896c7f0c33614fec20ea3ba0680bc9e', '2%7VUxi2', '13257721069', '1119485678@qq.com', 6, 6, '2020-11-08 14:25:03', '2020-11-11 21:12:35', 0, 1, 'root', 'root');
COMMIT;

-- ----------------------------
-- Table structure for user_role
-- ----------------------------
DROP TABLE IF EXISTS `user_role`;
CREATE TABLE `user_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户id',
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色id',
  `created_by` bigint(20) DEFAULT NULL COMMENT '创建者id',
  `modified_by` bigint(20) DEFAULT NULL COMMENT '修改者id',
  `gmt_created` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT NULL COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标志(默认0:未删除,1:已删除)',
  `version` bigint(60) NOT NULL DEFAULT '0' COMMENT '乐观锁版本',
  `creator` varchar(64) DEFAULT NULL COMMENT '创建者',
  `modifier` varchar(64) DEFAULT NULL COMMENT '更新者',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of user_role
-- ----------------------------
BEGIN;
INSERT INTO `user_role` VALUES (1, 6, 1, 6, 6, '2020-10-24 16:29:47', '2020-10-24 16:29:53', 0, 0, 'root', 'root');
INSERT INTO `user_role` VALUES (2, 7, 2, 6, 6, '2020-10-24 16:29:49', '2020-10-24 16:29:55', 0, 0, 'root', 'root');
INSERT INTO `user_role` VALUES (3, 8, 1, 6, 6, '2020-11-08 14:25:03', '2020-11-08 14:25:03', 0, 0, 'root', 'root');
INSERT INTO `user_role` VALUES (7, 9, 1, 6, 6, '2021-02-12 17:14:01', '2021-02-12 17:14:01', 0, 0, 'root', 'root');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
